let mysql = require('mysql');
let server = require('express')();
const port = 81;


//跨域
server.all("*", function(req, res, next) {
        //设置允许跨域的域名，*代表允许任意域名跨域
        res.header("Access-Control-Allow-Origin", "*");
        //允许的header类型
        res.header("Access-Control-Allow-Headers", "content-type");
        //跨域允许的请求方式 
        res.header("Access-Control-Allow-Methods", "DELETE,PUT,POST,GET,OPTIONS");
        if (req.method.toLowerCase() == 'options')
            res.send(200); //让options尝试请求快速结束
        else
            next();
    })
    // 规划链接

let sql = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '1234',
    database: 'solutionlist'
});

// 尝试链接
sql.connect();
//执行sql任务
server.get("/caselists", function(requst, response) {
    sql.query(`SELECT id,smallimg,h3,p  FROM caselist`, function(error, data) {
        if (error) {
            console.log(error)
        } else {
            response.end(JSON.stringify(data));
        }
    })
})
server.get("/casedetail", function(request, response) {
    let id = request.query.id;
    sql.query(`SELECT * FROM caselist WHERE id=${id}`, function(error, data) {
        if (error) {
            console.log(error)
        } else {
            response.end(JSON.stringify(data));
            console.log(id);

        }
    })
})



server.get("/solutionlist", function(request, response) {
    sql.query(`SELECT id,year,day,details  FROM solutions`, function(error, data) {
        if (error) {
            console.log(error)
        } else {
            response.end(JSON.stringify(data));
        }
    })
})



server.get("/solutiondetails", function(request, response) {
    let id = request.query.id;
    sql.query(`SELECT * FROM solutions WHERE id=${id}`, function(error, data) {
        if (error) {
            console.log(error)
        } else {
            response.end(JSON.stringify(data));
            console.log(id);
        }
    })
})
server.listen(port);
console.log(`server is running at ${port}`);